<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Contents</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<span class="sel"><font color="#ffcc00">Table of Contents</font></span>
</li>
         
<li>
<a href="../../manuals/reference/sqlj275.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<a href="../../manuals/develop/develop02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<a href="../../manuals/tuning/perf02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tuning/perf121.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Contents</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Reference+Manual">Reference Manual</a>
</li>
<li>
<a href="#Contents">Contents</a>
</li>
</ul>
<a name="N1003A"></a><a name="Reference+Manual"></a>
<h3>Reference Manual</h3>
<div style="margin-left: 0 ; border: 2px">
<br>
<hr>
</div>
<a name="N10040"></a><a name="Contents"></a>
<h3>Contents</h3>
<div style="margin-left: 0 ; border: 2px">
<p>
<a href="sqlj.html">Copyright</a>
<br>
</p>
<p>
<a href="sqlj03.html#HDRRMPREF1002477">About This Document</a>
<br>
</p>
<ul>
<li>
<a href="sqlj04.html#HDRSII-RMPREF-11181">Purpose of This Document</a>
</li>
<li>
<a href="sqlj05.html#HDRSII-RMPREF-23223">Audience</a>
</li>
<li>
<a href="sqlj06.html#HDRSII-RMPREF-23947">How This Document Is Organized</a>
</li>
</ul>
<p>
<a href="sqlj07.html#HDRSII-SQLJ-23296">SQL Language Reference</a>
<br>
</p>
<ul>
<li>
<a href="sqlj08.html#HDRSII-SQLJ-28468">Capitalization and Special Characters</a>
</li>
<li>
<a href="sqlj09.html#HDRSII-SQLJ-18919">SQL Identifiers</a> 
<ul>
<li>
<a href="sqlj10.html#HDRSQLJ1003454">Rules for SQL92Identifiers</a>
</li>
<li>
<a href="sqlj11.html#HDRSII-SQLJ-34834">SQL92Identifier</a> 
<ul>
<li>
<a href="sqlj11.html#HDRSQLJ1004091">Qualifying Dictionary Objects</a>
</li>
</ul>
</li>
<li>
<a href="sqlj12.html#HDRI1013074">schema-Name</a>
</li>
<li>
<a href="sqlj13.html#HDRI1021754">table-Name</a>
</li>
<li>
<a href="sqlj14.html#HDRI1197340">new-table-Name</a>
</li>
<li>
<a href="sqlj15.html#HDRI1197642">view-Name</a>
</li>
<li>
<a href="sqlj16.html#HDRI1008110">correlation-Name</a>
</li>
<li>
<a href="sqlj17.html#HDRI1044825">column-Name</a>
</li>
<li>
<a href="sqlj18.html#HDRI1007841">Simple-column-Name</a>
</li>
<li>
<a href="sqlj19.html#HDRI1007826">index-Name</a>
</li>
<li>
<a href="sqlj20.html#HDRI1008065">constraint-Name</a>
</li>
<li>
<a href="sqlj21.html#HDRI1008568">cursor-Name</a>
</li>
<li>
<a href="sqlj22.html#HDRI1148995">TriggerName</a>
</li>
<li>
<a href="sqlj23.html#HDRI1140981">AuthorizationIdentifier</a>
</li>
</ul>
</li>
<li>
<a href="sqlj24.html#HDRSII-SQLJ-39374">Statements</a> 
<ul>
<li>
<a href="sqlj25.html#HDRSII-SQLJ-22771">Interaction with the Dependency System</a>
</li>
<li>
<a href="sqlj26.html#HDRSII-SQLJ-81859">ALTER TABLE statement</a> 
<ul>
<li>
<a href="sqlj26.html#HDRSII-SQLJ-33145">ALTER TABLE</a>
</li>
</ul>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-95081">CREATE Statements</a> 
<ul>
<li>
<a href="sqlj27.html#HDRCREATEFUNCTIONSTATEMENT">CREATE FUNCTION Statement</a>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-20937">CREATE INDEX statement</a>
</li>
<li>
<a href="sqlj27.html#HDRCREATEPROCEDURESTATEMENT">CREATE PROCEDURE Statement</a>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-31580">CREATE SCHEMA statement</a>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-24513">CREATE TABLE statement</a>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-43125">CREATE TRIGGER statement</a>
</li>
<li>
<a href="sqlj27.html#HDRSII-SQLJ-15446">CREATE VIEW statement</a>
</li>
</ul>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-80721">DROP Statements</a> 
<ul>
<li>
<a href="sqlj28.html#HDRDROPFUNCTIONSTATEMENT">DROP FUNCTION</a>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-59893">DROP INDEX statement</a>
</li>
<li>
<a href="sqlj28.html#HDRDROPPROCEDURESTATEMENT">DROP PROCEDURE</a>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-31648">DROP SCHEMA statement</a>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-34148">DROP TABLE statement</a>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-42082">DROP TRIGGER statement</a>
</li>
<li>
<a href="sqlj28.html#HDRSII-SQLJ-61102">DROP VIEW statement</a>
</li>
</ul>
</li>
<li>
<a href="sqlj29.html#HDRSII-SQLJ-RENAMESTATEMENTS">RENAME Statements</a> 
<ul>
<li>
<a href="sqlj29.html#HDRSII-SQLJ-95598">RENAME INDEX statement</a>
</li>
<li>
<a href="sqlj29.html#HDRSII-SQLJ-RENAMETABLESTATEMENT">RENAME TABLE statement</a>
</li>
</ul>
</li>
<li>
<a href="sqlj30.html#HDRSII-SQLJ-35312">SET Statements</a> 
<ul>
<li>
<a href="sqlj30.html#HDRSII-SQLJ-32268">SET SCHEMA statement</a>
</li>
<li>
<a href="sqlj30.html#HDRSII-SQLJ-41180">SET CURRENT ISOLATION statement</a>
</li>
</ul>
</li>
<li>
<a href="sqlj31.html#HDRCALLPROCEDURE">CALL (PROCEDURE)</a>
</li>
<li>
<a href="sqlj32.html#HDRSII-SQLJ-13590">CONSTRAINT clause</a>
</li>
<li>
<a href="sqlj33.html#HDRDECLARETEMPTABLE">DECLARE GLOBAL TEMPORARY TABLE statement</a> 
<ul>
<li>
<a href="sqlj33.html#HDRTEMPTABLEDATATYPE">Data-type</a>
</li>
<li>
<a href="sqlj33.html#HDRTEMPTABLEONCOMMIT">ON COMMIT</a>
</li>
<li>
<a href="sqlj33.html#HDRTEMPTABLENOTLOGGED">NOT LOGGED</a>
</li>
</ul>
</li>
<li>
<a href="sqlj34.html#HDRSII-SQLJ-35981">DELETE statement</a>
</li>
<li>
<a href="sqlj35.html#HDRSII-SQLJ-31783">FOR UPDATE clause</a>
</li>
<li>
<a href="sqlj36.html#HDRSII-SQLJ-21583">FROM clause</a>
</li>
<li>
<a href="sqlj37.html#HDRSII-SQLJ-32654">GROUP BY clause</a>
</li>
<li>
<a href="sqlj38.html#HDRSII-SQLJ-14854">HAVING clause</a>
</li>
<li>
<a href="sqlj39.html#HDRSII-SQLJ-35034">INNER JOIN</a>
</li>
<li>
<a href="sqlj40.html#HDRSII-SQLJ-40774">INSERT statement</a>
</li>
<li>
<a href="sqlj41.html#HDRSII-SQLJ-29840">JOIN operation</a>
</li>
<li>
<a href="sqlj42.html#HDRSII-SQLJ-18922">LEFT OUTER JOIN</a>
</li>
<li>
<a href="sqlj43.html#HDRSII-SQLJ-40506">LOCK TABLE statement</a>
</li>
<li>
<a href="sqlj44.html#HDRSII-SQLJ-13658">ORDER BY clause</a>
</li>
<li>
<a href="sqlj45.html#HDRSII-SQLJ-21571">Query</a>
</li>
<li>
<a href="sqlj46.html#HDRSII-SQLJ-57522">RIGHT OUTER JOIN</a>
</li>
<li>
<a href="sqlj47.html#HDRI1044591">ScalarSubquery</a>
</li>
<li>
<a href="sqlj48.html#HDRI1118737">SelectExpression</a>
</li>
<li>
<a href="sqlj49.html#HDRSII-SQLJ-41360">SELECT statement</a>
</li>
<li>
<a href="sqlj50.html#HDRI1090926">TableExpression</a>
</li>
<li>
<a href="sqlj51.html#HDRI1008429">TableSubquery</a>
</li>
<li>
<a href="sqlj52.html#HDRSII-SQLJ-26498">UPDATE statement</a>
</li>
<li>
<a href="sqlj53.html#HDRSII-SQLJ-11277">VALUES expression</a>
</li>
<li>
<a href="sqlj54.html#HDRSII-SQLJ-33602">WHERE clause</a>
</li>
<li>
<a href="sqlj55.html#HDRSII-SQLJ-15309">WHERE CURRENT OF clause</a>
</li>
</ul>
</li>
<li>
<a href="sqlj56.html#HDRSII-SQLJ-29026">Built-In Functions</a> 
<ul>
<li>
<a href="sqlj57.html#HDRSII-SQLJ-55788">Standard Built-In Functions</a>
</li>
<li>
<a href="sqlj58.html#HDRSII-SQLJ-33923">Aggregates (Set Functions)</a>
</li>
<li>
<a href="sqlj59.html#HDRSII-SQLJ-98067">ABS or ABSVAL</a>
</li>
<li>
<a href="sqlj60.html#HDRSII-SQLJ-32693">AVG</a>
</li>
<li>
<a href="sqlj61.html#HDRBUILTBIGINT">BIGINT</a>
</li>
<li>
<a href="sqlj62.html#HDRSII-SQLJ-33562">CAST</a>
</li>
<li>
<a href="sqlj63.html#HDRBUILTCHAR">CHAR</a>
</li>
<li>
<a href="sqlj64.html#HDRSII-SQLJ-16762">LENGTH</a>
</li>
<li>
<a href="sqlj65.html#HDRSII-SQLJ-40899">Concatenation</a>
</li>
<li>
<a href="sqlj66.html#HDRCASENULLIF">NULLIF and CASE expressions</a>
</li>
<li>
<a href="sqlj67.html#HDRSII-SQLJ-38716">COUNT</a>
</li>
<li>
<a href="sqlj68.html#HDRSII-SQLJ-66113">COUNT(*)</a>
</li>
<li>
<a href="sqlj69.html#HDRSII-SQLJ-CURRENTDATE">CURRENT DATE</a>
</li>
<li>
<a href="sqlj70.html#HDRSII-SQLJ-34177">CURRENT_DATE</a>
</li>
<li>
<a href="sqlj71.html#HDRCURRENTISOLATION">CURRENT ISOLATION</a>
</li>
<li>
<a href="sqlj72.html#HDRSII-SQLJ-CURRENTSCHEMA">CURRENT SCHEMA</a>
</li>
<li>
<a href="sqlj73.html#HDRSQLJ1055824">CURRENT TIME</a>
</li>
<li>
<a href="sqlj74.html#HDRSII-SQLJ-33772">CURRENT_TIME</a>
</li>
<li>
<a href="sqlj75.html#HDRSII-SQLJ-CURRENTTIMESTAMP">CURRENT TIMESTAMP</a>
</li>
<li>
<a href="sqlj76.html#HDRSII-SQLJ-15866">CURRENT_TIMESTAMP</a>
</li>
<li>
<a href="sqlj77.html#HDRSII-SQLJ-42324">CURRENT_USER</a>
</li>
<li>
<a href="sqlj78.html#HDRDATEFUNC">DATE</a>
</li>
<li>
<a href="sqlj79.html#HDRDAYFUNC">DAY</a>
</li>
<li>
<a href="sqlj80.html#HDRBUILTDOUBLE">DOUBLE</a>
</li>
<li>
<a href="sqlj81.html#HDRHOURFUNC">HOUR</a>
</li>
<li>
<a href="sqlj82.html#HDRIDENTITYVALLOCAL">IDENTITY_VAL_LOCAL</a>
</li>
<li>
<a href="sqlj83.html#HDRBUILTINTEGER">INTEGER</a>
</li>
<li>
<a href="sqlj84.html#HDRSII-SQLJ-61998">LOCATE</a>
</li>
<li>
<a href="sqlj85.html#HDRSII-SQLJ-42049">LCASE or LOWER</a>
</li>
<li>
<a href="sqlj86.html#HDRSII-SQLJ-97870">LTRIM</a>
</li>
<li>
<a href="sqlj87.html#HDRSII-SQLJ-27781">MAX</a>
</li>
<li>
<a href="sqlj88.html#HDRSII-SQLJ-33520">MIN</a>
</li>
<li>
<a href="sqlj89.html#HDRMINUTEFUNC">MINUTE</a>
</li>
<li>
<a href="sqlj90.html#HDRSII-SQLJ-MOD">MOD</a>
</li>
<li>
<a href="sqlj91.html#HDRMONTHFUNC">MONTH</a>
</li>
<li>
<a href="sqlj92.html#HDRSII-SQLJ-32613">RTRIM</a>
</li>
<li>
<a href="sqlj93.html#HDRSECONDFUNC">SECOND</a>
</li>
<li>
<a href="sqlj94.html#HDRSII-SQLJ-25228">SESSION_USER</a>
</li>
<li>
<a href="sqlj95.html#HDRBUILTSMALLINT">SMALLINT</a>
</li>
<li>
<a href="sqlj96.html#HDRSII-SQLJ-73147">SQRT</a>
</li>
<li>
<a href="sqlj97.html#HDRSII-SQLJ-93082">SUBSTR</a>
</li>
<li>
<a href="sqlj98.html#HDRSII-SQLJ-13083">SUM</a>
</li>
<li>
<a href="sqlj99.html#HDRTIMEFUNC">TIME</a>
</li>
<li>
<a href="sqlj100.html#HDRTIMESTAMPFUNC">TIMESTAMP</a>
</li>
<li>
<a href="sqlj101.html#HDRSII-SQLJ-29930">UCASE or UPPER</a>
</li>
<li>
<a href="sqlj102.html#HDRSII-SQLJ-42476">USER</a>
</li>
<li>
<a href="sqlj103.html#HDRBUILTVARCHAR">VARCHAR</a>
</li>
<li>
<a href="sqlj104.html#HDRYEARFUNC">YEAR</a>
</li>
</ul>
</li>
<li>
<a href="sqlj105.html#HDRSQLBUILTINSYSTEMFUNCTIONS">Built-in system functions</a> 
<ul>
<li>
<a href="sqlj106.html#HDRSYSCSCHECKTABLEFUNC">SYSCS_UTIL.SYSCS_CHECK_TABLE</a>
</li>
<li>
<a href="sqlj107.html#HDRSYSCSRUNTIMESTATSFUNC">SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS</a>
</li>
<li>
<a href="sqlj108.html#HDRGETDBPROPFUNC">SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY</a>
</li>
</ul>
</li>
<li>
<a href="sqlj109.html#HDRSQLBUILTINSYSTEMPROCEDURES">Built-in system procedures</a> 
<ul>
<li>
<a href="sqlj110.html#HDRALTERTABLECOMPRESS">SYSCS_UTIL.SYSCS_COMPRESS_TABLE</a>
</li>
<li>
<a href="sqlj111.html#HDRSII-SQLJ-38831">SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS</a>
</li>
<li>
<a href="sqlj112.html#HDRSETSTATSTIMINGPROC">SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING</a>
</li>
<li>
<a href="sqlj113.html#HDRSETDBPROPPROC">SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</a>
</li>
<li>
<a href="sqlj114.html#HDRFREEZEDBPROC">SYSCS_UTIL.SYSCS_FREEZE_DATABASE</a>
</li>
<li>
<a href="sqlj115.html#HDRUNFREEZEDBPROC">SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE</a>
</li>
<li>
<a href="sqlj116.html#HDRCHECKPOINTDBPROC">SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE</a>
</li>
<li>
<a href="sqlj117.html#HDRBACKUPDBPROC">SYSCS_UTIL.SYSCS_BACKUP_DATABASE</a>
</li>
<li>
<a href="sqlj118.html#HDREXPORTPROC">SYSCS_UTIL.SYSCS_EXPORT_TABLE</a>
</li>
<li>
<a href="sqlj119.html#HDREXPORTSELECTIONPROC">SYSCS_UTIL.SYSCS_EXPORT_QUERY</a>
</li>
<li>
<a href="sqlj120.html#HDRIMPORTPROC">SYSCS_UTIL.SYSCS_IMPORT_TABLE</a>
</li>
<li>
<a href="sqlj121.html#HDRIMPORTDATAPROC">SYSCS_UTIL.SYSCS_IMPORT_DATA</a>
</li>
</ul>
</li>
<li>
<a href="sqlj122.html#HDRSII-SQLJ-31068">Data Types</a> 
<ul>
<li>
<a href="sqlj123.html#HDRSII-SQLJ-21305">Built-In Type Overview</a>
</li>
<li>
<a href="sqlj124.html#HDRSII-SQLJ-41507">Numeric Types</a> 
<ul>
<li>
<a href="sqlj124.html#HDRSII-SQLJ-28138">Numeric Type Overview</a>
</li>
<li>
<a href="sqlj124.html#HDRSII-SQLJ-27767">Numeric Type Promotion in Expressions</a>
</li>
<li>
<a href="sqlj124.html#HDRSII-SQLJ-20204">Storing Values of One Numeric Data Type in Columns of Another Numeric Data Type</a>
</li>
<li>
<a href="sqlj124.html#HDRSII-SQLJ-36146">Scale for Decimal Arithmetic</a>
</li>
</ul>
</li>
<li>
<a href="sqlj125.html#HDRSII-SQLJ-58560">Data type assignments and comparison, sorting, and ordering</a>
</li>
<li>
<a href="sqlj126.html#HDRSII-SQLJ-30435">BIGINT</a>
</li>
<li>
<a href="sqlj127.html#HDRBLOB">BLOB</a>
</li>
<li>
<a href="sqlj128.html#HDRSII-SQLJ-13733">CHAR</a>
</li>
<li>
<a href="sqlj129.html#HDRSII-SQLJ-57924">CHAR FOR BIT DATA</a>
</li>
<li>
<a href="sqlj130.html#HDRCLOB">CLOB</a>
</li>
<li>
<a href="sqlj131.html#HDRSII-SQLJ-18730">DATE</a>
</li>
<li>
<a href="sqlj132.html#HDRSII-SQLJ-15260">DECIMAL</a>
</li>
<li>
<a href="sqlj133.html#HDRSII-SQLJ-42002">DOUBLE</a>
</li>
<li>
<a href="sqlj134.html#HDRSII-SQLJ-DOUBLEPRECISION">DOUBLE PRECISION</a>
</li>
<li>
<a href="sqlj135.html#HDRSII-SQLJ-27281">FLOAT</a>
</li>
<li>
<a href="sqlj136.html#HDRSII-SQLJ-10696">INTEGER</a>
</li>
<li>
<a href="sqlj137.html#HDRSII-SQLJ-15147">LONG VARCHAR</a>
</li>
<li>
<a href="sqlj138.html#HDRSII-SQLJ-30118">LONG VARCHAR FOR BIT DATA</a>
</li>
<li>
<a href="sqlj139.html#HDRSII-SQLJ-12362">NUMERIC</a>
</li>
<li>
<a href="sqlj140.html#HDRSII-SQLJ-14122">REAL</a>
</li>
<li>
<a href="sqlj141.html#HDRSII-SQLJ-16221">SMALLINT</a>
</li>
<li>
<a href="sqlj142.html#HDRSII-SQLJ-21908">TIME</a>
</li>
<li>
<a href="sqlj143.html#HDRSII-SQLJ-27620">TIMESTAMP</a>
</li>
<li>
<a href="sqlj144.html#HDRSII-SQLJ-41207">VARCHAR</a>
</li>
<li>
<a href="sqlj145.html#HDRSII-SQLJ-32714">VARCHAR FOR BIT DATA</a>
</li>
</ul>
</li>
<li>
<a href="sqlj146.html#HDRSII-SQLJ-19433">SQL Expressions</a> 
<ul>
<li>
<a href="sqlj147.html#HDRSQLJ1080779">Expression Precedence</a> 
<ul>
<li>
<a href="sqlj147.html#HDRSQLJ1080962">Example</a>
</li>
</ul>
</li>
<li>
<a href="sqlj148.html#HDRSII-SQLJ-23075">Boolean expression</a>
</li>
<li>
<a href="sqlj149.html#HDRSII-SQLJ-29911">Dynamic Parameters</a> 
<ul>
<li>
<a href="sqlj149.html#HDRSQLJ1082953">Dynamic Parameters Example</a>
</li>
<li>
<a href="sqlj149.html#HDRSQLJ1083019">Where Dynamic Parameters Are Allowed</a>
</li>
</ul>
</li>
</ul>
</li>
</ul>
<p>
<a href="sqlj150.html#HDRSII-KEYWORDS-29722">SQL Reserved Words</a>
<br>
</p>
<p>
<a href="sqlj151.html#HDRSII-SQL92-41891">Derby Support for SQL-92 Features</a>
<br>
</p>
<p>
<a href="sqlj152.html#HDRSII-SISTABS-38369">Derby System Tables</a>
<br>
</p>
<ul>
<li>
<a href="sqlj153.html#HDRSII-SISTABS-28114">SYSALIASES</a>
</li>
<li>
<a href="sqlj154.html#HDRSII-SISTABS-26665">SYSCHECKS</a>
</li>
<li>
<a href="sqlj155.html#HDRSII-SISTABS-22441">SYSCOLUMNS</a>
</li>
<li>
<a href="sqlj156.html#HDRSII-SISTABS-39391">SYSCONGLOMERATES</a>
</li>
<li>
<a href="sqlj157.html#HDRSII-SISTABS-23241">SYSCONSTRAINTS</a>
</li>
<li>
<a href="sqlj158.html#HDRSII-SISTABS-12813">SYSDEPENDS</a>
</li>
<li>
<a href="sqlj159.html#HDRSII-SISTABS-40972">SYSFILES</a>
</li>
<li>
<a href="sqlj160.html#HDRSII-SISTABS-13420">SYSFOREIGNKEYS</a>
</li>
<li>
<a href="sqlj161.html#HDRSII-SISTABS-33921">SYSKEYS</a>
</li>
<li>
<a href="sqlj162.html#HDRSII-SISTABS-12085">SYSSCHEMAS</a>
</li>
<li>
<a href="sqlj163.html#HDRSII-SISTABS-LILANGUAGEITEMSYSSTATISTICS">SYSSTATISTICS</a>
</li>
<li>
<a href="sqlj164.html#HDRSII-SISTABS-33768">SYSSTATEMENTS</a>
</li>
<li>
<a href="sqlj165.html#HDRSII-SISTABS-24269">SYSTABLES</a>
</li>
<li>
<a href="sqlj166.html#HDRSII-SISTABS-79888">SYSTRIGGERS</a>
</li>
<li>
<a href="sqlj167.html#HDRSII-SISTABS-24045">SYSVIEWS</a>
</li>
</ul>
<p>
<a href="sqlj168.html#HDRSII-EXCEPT-16677">Derby Exception Messages and SQL States</a>
<br>
</p>
<ul>
<li>
<a href="sqlj169.html#HDRSII-EXCEPT-75154">Understanding SQLExceptions</a>
</li>
<li>
<a href="sqlj170.html#HDRSII-EXCEPT-71493">SQLState and Error Message Reference</a> 
<ul>
<li>
<a href="sqlj171.html#HDRSII-EXCEPT-13113">Common Exceptions</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="sqlj172.html#HDRSII-JDBC-12657">JDBC Reference</a>
<br>
</p>
<ul>
<li>
<a href="sqlj173.html#HDRSII-JDBC-25142">Core JDBC java.sql Classes, Interfaces, and Methods</a>
</li>
<li>
<a href="sqlj174.html#HDRSII-JDBC-32052">java.sql.Driver</a> 
<ul>
<li>
<a href="sqlj175.html#HDRSII-JDBC-29973">Embedded Databases</a>
</li>
</ul>
</li>
<li>
<a href="sqlj176.html#HDRSII-JDBC-34565">java.sql.DriverManager.getConnection</a> 
<ul>
<li>
<a href="sqlj177.html#HDRSII-JDBC-27433">Derby Database Connection URL Syntax</a>
</li>
<li>
<a href="sqlj178.html#HDRSII-JDBC-37352">Embedded Databases</a>
</li>
<li>
<a href="sqlj179.html#Header_246">Additional Syntax</a>
</li>
<li>
<a href="sqlj180.html#HDRSII-JDBC-10889">The Derby Database Connection URL Attributes</a>
</li>
</ul>
</li>
<li>
<a href="sqlj181.html#HDRSII-JDBC-34954">java.sql.Driver.getPropertyInfo</a>
</li>
<li>
<a href="sqlj182.html#HDRSII-JDBC-27734">java.sql.Connection</a> 
<ul>
<li>
<a href="sqlj183.html#Header_250">java.sql.Connection.setTransactionIsolation</a>
</li>
<li>
<a href="sqlj184.html#Header_251">java.sql.Connection.setReadOnly</a>
</li>
<li>
<a href="sqlj185.html#Header_252">java.sql.Connection.isReadOnly</a>
</li>
<li>
<a href="sqlj186.html#Header_253">Connection Functionality Not Supported</a>
</li>
</ul>
</li>
<li>
<a href="sqlj187.html#HDRSII-JDBC-15905">java.sql.DatabaseMetaData</a> 
<ul>
<li>
<a href="sqlj188.html#HDRDMRS">DatabaseMetaData Result Sets</a>
</li>
<li>
<a href="sqlj189.html#HDRGPC1">getProcedureColumns</a>
</li>
<li>
<a href="sqlj190.html#HDRPGC1">Parameters to getProcedureColumns</a>
</li>
<li>
<a href="sqlj191.html#HDRCRSRGPC1">Columns in the ResultSet Returned by <strong>getProcedureColumns</strong></a>
</li>
<li>
<a href="sqlj192.html#HDRDMDFNS1">DatabaseMetaData functionality not supported</a>
</li>
</ul>
</li>
<li>
<a href="sqlj193.html#HDRSII-JDBC-40794">java.sql.Statement</a> 
<ul>
<li>
<a href="sqlj194.html#HDRRSO2">ResultSet Objects</a>
</li>
<li>
<a href="sqlj195.html#HDRJSSFNS2">java.sql.Statement functionality not supported</a>
</li>
</ul>
</li>
<li>
<a href="sqlj196.html#HDRSII-JDBC-29874">java.sql.PreparedStatement</a> 
<ul>
<li>
<a href="sqlj197.html#Header_264">Streaming Columns</a>
</li>
</ul>
</li>
<li>
<a href="sqlj198.html#HDRSII-JDBC-20485">java.sql.CallableStatement</a> 
<ul>
<li>
<a href="sqlj199.html#Header_266">CallableStatements and OUT Parameters</a>
</li>
<li>
<a href="sqlj200.html#HDRSII-JDBC-75719">CallableStatements and INOUT Parameters</a>
</li>
</ul>
</li>
<li>
<a href="sqlj201.html#HDRSII-JDBC-23502">java.sql.ResultSet</a> 
<ul>
<li>
<a href="sqlj202.html#Header_269">Streaming Columns</a>
</li>
</ul>
</li>
<li>
<a href="sqlj203.html#HDRSII-JDBC-38274">java.sql.ResultSetMetaData</a> 
<ul>
<li>
<a href="sqlj204.html#HDRSAUADT3">Source and updatability (all data types)</a>
</li>
</ul>
</li>
<li>
<a href="sqlj205.html#HDRSII-JDBC-16643">java.sql.SQLException</a>
</li>
<li>
<a href="sqlj206.html#HDRSII-JDBC-30469">java.sql.SQLWarning</a>
</li>
<li>
<a href="sqlj207.html#HDRSII-JDBC-20377">java.sql.Types</a>
</li>
<li>
<a href="sqlj208.html#HDRSII-JDBC-96386">java.sql.Blob and java.sql.Clob</a> 
<ul>
<li>
<a href="sqlj209.html#Header_276">Notes</a>
</li>
</ul>
</li>
<li>
<a href="sqlj210.html#HDRSII-JDBC-80004">java.sql.Connection</a>
</li>
<li>
<a href="sqlj211.html#HDRSII-JDBC-77156">java.sql.ResultSet</a>
</li>
<li>
<a href="sqlj212.html#HDRSII-JDBC-59162">java.sql.Statement</a>
</li>
<li>
<a href="sqlj213.html#HDRSII-JDBC-99392">java.sql.PreparedStatement</a>
</li>
<li>
<a href="sqlj214.html#HDRSII-JDBC-52637">java.sql.CallableStatement</a>
</li>
<li>
<a href="sqlj215.html#HDRSII-JDBC-66688">java.sql.DatabaseMetaData</a>
</li>
<li>
<a href="sqlj216.html#HDRSII-JDBC-71949">java.sql.ResultSetMetaData</a>
</li>
<li>
<a href="sqlj217.html#HDRSII-JDBC-87220">java.sql.BatchUpdateException</a>
</li>
<li>
<a href="sqlj218.html#HDRSII-JDBC-32593">JDBC 3.0-Only Features</a>
</li>
<li>
<a href="sqlj219.html#HDRSII-JDBC-JAVASQLCONNECTION30">java.sql.Connection</a>
</li>
<li>
<a href="sqlj220.html#HDRSII-JDBC-DATABASEMETADATA30">java.sql.DatabaseMetaData</a>
</li>
<li>
<a href="sqlj221.html#HDRSII-JDBC-PARAMETERMETADATA30">java.sql.ParameterMetaData</a>
</li>
<li>
<a href="sqlj222.html#HDRSII-JDBC-JAVASQLPREPAREDSTATEMENT30">java.sql.PreparedStatement</a>
</li>
<li>
<a href="sqlj223.html#HDRSII-JDBC-JAVASQLSAVEPOINT">java.sql.Savepoint</a> 
<ul>
<li>
<a href="sqlj224.html#Header_291">Setting and Rolling Back to a Savepoint</a>
</li>
<li>
<a href="sqlj225.html#Header_292">Releasing a Savepoint</a>
</li>
<li>
<a href="sqlj226.html#Header_293">Rules</a>
</li>
<li>
<a href="sqlj227.html#Header_294">Restrictions</a>
</li>
</ul>
</li>
<li>
<a href="sqlj228.html#HDRSII-JDBC-JAVASQLSTATEMENT30">java.sql.Statement</a> 
<ul>
<li>
<a href="sqlj229.html#Header_296">Autogenerated Keys</a>
</li>
</ul>
</li>
<li>
<a href="sqlj230.html#HDRJDBC1020262">JDBC Escape Syntax</a> 
<ul>
<li>
<a href="sqlj231.html#HDRSII-JDBC-70824">call</a>
</li>
<li>
<a href="sqlj232.html#HDRSII-JDBC-27768">d</a>
</li>
<li>
<a href="sqlj233.html#HDRSII-JDBC-28456">escape</a>
</li>
<li>
<a href="sqlj234.html#HDRSII-JDBC-88908">fn</a>
</li>
<li>
<a href="sqlj235.html#HDRSII-JDBC-37244">oj</a>
</li>
<li>
<a href="sqlj236.html#HDRSII-JDBC-12124">t</a>
</li>
<li>
<a href="sqlj237.html#HDRSII-JDBC-41784">ts</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="sqlj238.html#HDRSII-ATTRIB-24612">Database Connection URL Attributes</a>
<br>
</p>
<ul>
<li>
<a href="sqlj239.html#HDRSII-ATTRIB-42100">bootPassword=key</a>
</li>
<li>
<a href="sqlj240.html#HDRSII-ATTRIB-26867">create=true</a>
</li>
<li>
<a href="sqlj241.html#HDRSII-ATTRIB-17246">databaseName=nameofDatabase</a>
</li>
<li>
<a href="sqlj242.html#HDRSII-ATTRIB-15290">dataEncryption=true</a>
</li>
<li>
<a href="sqlj243.html#HDRSII-ATTRIB-88843">encryptionProvider=providerName</a>
</li>
<li>
<a href="sqlj244.html#HDRSII-ATTRIB-60346">encryptionAlgorithm=algorithm</a>
</li>
<li>
<a href="sqlj245.html#HDRSII-ATTRIB-56769">territory=ll_CC</a>
</li>
<li>
<a href="sqlj246.html#HDRSII-ATTRIB-72457">logDevice=logDirectoryPath</a>
</li>
<li>
<a href="sqlj247.html#HDRSII-ATTRIB-42686">password=userPassword</a>
</li>
<li>
<a href="sqlj248.html#HDRROLL-FORWARD">rollForwardRecoveryFrom=Path</a>
</li>
<li>
<a href="sqlj249.html#HDRCREATEFROM">createFrom=Path</a>
</li>
<li>
<a href="sqlj250.html#HDRRESTOREFROM">restoreFrom=Path</a>
</li>
<li>
<a href="sqlj251.html#HDRSII-ATTRIB-16471">shutdown=true</a>
</li>
<li>
<a href="sqlj252.html#HDRSII-ATTRIB-10035">user=userName</a>
</li>
<li>
<a href="sqlj253.html#HDRSII-ATTRIB-34183">(no attributes)</a>
</li>
</ul>
<p>
<a href="sqlj254.html#HDRSII-JTA-16677">J2EE Compliance: Java Transaction API and javax.sql Extensions</a>
<br>
</p>
<ul>
<li>
<a href="sqlj255.html#HDRSII-JTA-37588">J2EE Overview</a> 
<ul>
<li>
<a href="sqlj256.html#HDRSII-JTA-94396">JVM and Libraries for J2EE Features</a>
</li>
</ul>
</li>
<li>
<a href="sqlj257.html#HDRSII-JTA-51021">The JTA API</a> 
<ul>
<li>
<a href="sqlj258.html#HDRJTA1003392">Notes on Product Behavior</a> 
<ul>
<li>
<a href="sqlj258.html#HDRJTA1003415">Recovered Global Transactions</a>
</li>
<li>
<a href="sqlj258.html#HDRJTA1003463">XAConnections and User Names and Passwords</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="sqlj259.html#HDRSII-JTA-18596">javax.sql: JDBC Extensions</a>
</li>
</ul>
<p>
<a href="sqlj260.html#HDRSII-API-10613">Appendix A. Derby API</a>
<br>
</p>
<ul>
<li>
<a href="sqlj261.html#HDRSII-API-24806">Stand-Alone Tools and Utilities</a>
</li>
<li>
<a href="sqlj262.html#HDRSII-API-19690">JDBC Implementation Classes</a> 
<ul>
<li>
<a href="sqlj263.html#HDRSII-API-33761">JDBC Driver</a>
</li>
<li>
<a href="sqlj264.html#HDRAPI1003363">Data Source Classes</a>
</li>
</ul>
</li>
<li>
<a href="sqlj265.html#HDRAPI1005026">Miscellaneous Utilities and Interfaces</a>
</li>
</ul>
<p>
<a href="sqlj266.html#HDRSII-SQLJ-75638">Appendix B. Supported territories</a>
<br>
</p>
<p>
<a href="sqlj267.html#HDRREFLIMITS">Appendix C. Derby limitations</a>
<br>
</p>
<ul>
<li>
<a href="sqlj268.html#HDRIDLENGTHLIMITS">Identifier length limitations</a>
</li>
<li>
<a href="sqlj269.html#HDRNUMERICLIMITS">Numeric limitations</a>
</li>
<li>
<a href="sqlj270.html#HDRSTRINGLIMITS">String limitations</a>
</li>
<li>
<a href="sqlj271.html#HDRDTTLIMITS">DATE, TIME, and TIMESTAMP limitations</a>
</li>
<li>
<a href="sqlj272.html#HDRDBMLIMITS">Database Manager limitations</a>
</li>
</ul>
<p>
<a href="sqlj274.html#HDRTRADEM">Trademarks</a>
</p>
<p>
<a href="sqlj275.html#HDRINDEX_START">Index</a>
<br>
</p>
<hr>
<a href="sqlj.html">Previous Page</a>
<br>
<a href="sqlj03.html">Next Page</a>
<br>
<a href="#ToC">Table of Contents</a>
<br>
<a href="sqlj275.html#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
